ObligorDefinitionV3
one record per legal entity that owes - the CDS reference entity, the bond obligor, the muni obligated person the first ENTITY-layer record: section 18's second identity layer as an actual object
METADATA
| Attribute | Value |
|---|---|
| Topic | 9200-product-def-asset-class |
| MLink Token | ClientLive |
| Product | SRReference |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| obligorKey_at | enum - AssetType | PRI | 'None' | AT ENT TS SR regionneutral entities home ABOVE markets plain SR is reserved for exactly this |
| obligorKey_ts | enum - TickerSrc | PRI | 'None' | AT ENT TS SR regionneutral entities home ABOVE markets plain SR is reserved for exactly this |
| obligorKey_tk | VARCHAR(12) | PRI | '' | AT ENT TS SR regionneutral entities home ABOVE markets plain SR is reserved for exactly this |
| name | VARCHAR(32) | '' | display name | |
| legalName | TINYTEXT | '' | the registered legal name of the obligor | |
| entityClass | enum - CreditClass | 'None' | Corporate Sovereign Municipal Agency Supranational | |
| country | VARCHAR(2) | '' | ISO 31661 alpha2 country of the obligor CountryDefinitionV3 9000 | |
| stateProvince | VARCHAR(8) | '' | munis and subsovereigns | |
| parentObligorKey_at | enum - AssetType | 'None' | the immediate parent entity empty at the top of a group | |
| parentObligorKey_ts | enum - TickerSrc | 'None' | the immediate parent entity empty at the top of a group | |
| parentObligorKey_tk | VARCHAR(12) | '' | the immediate parent entity empty at the top of a group | |
| standingGuarantorKey_at | enum - AssetType | 'None' | full unconditional programmatic guarantee only a support agreement does not qualify | |
| standingGuarantorKey_ts | enum - TickerSrc | 'None' | full unconditional programmatic guarantee only a support agreement does not qualify | |
| standingGuarantorKey_tk | VARCHAR(12) | '' | full unconditional programmatic guarantee only a support agreement does not qualify | |
| creditEventStatus | enum - CreditEventStatus | 'None' | None Bankruptcy FailureToPay Restructuring AuctionPending Settled | |
| statusFlag | enum - TkStatusFlag | 'None' | Active or Delisted A delisted row stays resolvable and is never deleted | |
| pendingDelete | enum - YesNo | 'None' | Yes queued for removal stop resolving against this row | |
| sourceNote | TINYTEXT | '' | freetext provenance for this row | |
| v3Source | enum - V3Source | 'None' | Bridge projected from a legacy record Loader written natively None reads as Loader | |
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' | when this row was last written |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| obligorKey_tk | 1 |
| obligorKey_at | 2 |
| obligorKey_ts | 3 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRReference`.`MsgObligorDefinitionV3`
WHERE
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE','CRDT','GCR','SWAP','ENT','MBS','SET','LOAN') */
`obligorKey_at` = 'NONE'
AND
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX','CRCY','CMDY','DTI','SOVN','SR_US','SR_EU','SR_AP','SR_UK','USD','EUR','GBP','CHF','JPY','CAD','AUD','HKD','KRW','INR','SGD','TWD','CNY','CNH','BRL','MXN','ZAR','SEK','NOK','DKK','PLN','ILS','TRY','NZD','THB','MYR','IDR','PHP','CZK','HUF','SAR','AED','CLP','COP') */
`obligorKey_ts` = 'NONE'
AND
/* Replace with a VARCHAR(12) */
`obligorKey_tk` = 'Example_obligorKey_tk';
Doc Columns Query
SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='ObligorDefinitionV3' ORDER BY ordinal_position ASC;